﻿if exists (select 1
            from  sysobjects
           where  id = object_id('GXBZ_EMR_ZYBASY')
            and   type = 'U')
   drop table GXBZ_EMR_ZYBASY
go

/*==============================================================*/
/* Table: GXBZ_EMR_ZYBASY                                       */
/*==============================================================*/
create table GXBZ_EMR_ZYBASY (
   ZYLSH                varchar(64)          not null,
   XGBZ                 varchar(1)           not null,
   GRJBXXBSH            varchar(64)          not null,
   CXJMJKDABH           varchar(17)          not null,
   JKKH                 varchar(64)          null,
   ZYHBS                varchar(32)          null,
   BLH                  varchar(36)          null,
   BAH                  varchar(36)          null,
   XZZXMCMPH            varchar(140)         null,
   XZZCMC               varchar(70)          null,
   XZZXMC               varchar(70)          null,
   XZZQXMC              varchar(70)          null,
   XZZSMC               varchar(70)          null,
   XZZSSMC              varchar(70)          null,
   XZZYB                varchar(16)          null,
   XZZXXDZ              varchar(140)         null,
   CSDQXMC              varchar(70)          null,
   CSDDSMC              varchar(70)          null,
   CSDSSMC              varchar(70)          null,
   CSDYB                varchar(16)          null,
   CSDXXDZ              varchar(140)         null,
   GZDWMC               varchar(70)          null,
   GZDWDZDHHM           varchar(70)          null,
   GZDWDZMPH            varchar(140)         null,
   GZDWDZCMC            varchar(70)          null,
   GZDWDZXMC            varchar(70)          null,
   GZDWDZQXMC           varchar(70)          null,
   GZDWDZSMC            varchar(70)          null,
   GZDWSSMC             varchar(70)          null,
   GZDWDZYB             varchar(70)          null,
   GZDWXXDZ             varchar(140)         null,
   HJDZDZMPH            varchar(70)          null,
   HJDZDZCMC            varchar(70)          null,
   HJDZDZXMC            varchar(70)          null,
   HJDZQXMC             varchar(70)          null,
   HJDZSMC              varchar(70)          null,
   HJDZSSMC             varchar(70)          null,
   HJDZYB               varchar(16)          null,
   HJDXXDZ              varchar(140)         null,
   JGSMC                varchar(70)          null,
   JGSSMC               varchar(70)          null,
   ZYLBDM               varchar(4)           null,
   ZYLBMC               varchar(20)          null,
   YLJGDM               varchar(33)          null,
   YLJGMC               varchar(70)          null,
   KFSSGH               varchar(64)          null,
   KFYSXM               varchar(30)          null,
   WDGLJGDM             varchar(22)          null,
   WDGLJGMC             varchar(70)          null,
   KZRGH                varchar(64)          null,
   KZRXM                varchar(30)          null,
   ZRYSBM               varchar(64)          null,
   ZRYSXM               varchar(30)          null,
   ZZYSBM               varchar(64)          null,
   ZZYSXM               varchar(30)          null,
   ZYYSBM               varchar(64)          null,
   ZYYSXM               varchar(30)          null,
   ZRHSBM               varchar(64)          null,
   ZRHSXM               varchar(30)          null,
   JXYSBM               varchar(64)          null,
   JXYSXM               varchar(30)          null,
   SXYSBM               varchar(64)          null,
   SXYSXM               varchar(30)          null,
   BMYBM                varchar(64)          null,
   BMYXM                varchar(30)          null,
   YLXRGX               varchar(1)           null,
   LXRDZMPH             varchar(140)         null,
   LXRDZCMC             varchar(70)          null,
   LXRDZXMC             varchar(70)          null,
   LXRDZQXMC            varchar(70)          null,
   LXRDZSMC             varchar(70)          null,
   LXRDZSSMC            varchar(70)          null,
   LXRDZYB              varchar(16)          null,
   LXRXXDZ              varchar(140)         null,
   LXRDZDHHM            varchar(20)          null,
   LXRXM                varchar(30)          null,
   RYTJ                 varchar(1)           null,
   RYSJ                 datetime             null,
   CYSJ                 datetime             null,
   BFHBS                varchar(20)          null,
   RYKBBFMC             varchar(100)         null,
   RYKBDM               varchar(64)          null,
   RYKBMC               varchar(32)          null,
   XSERYTZ              varchar(64)          null,
   XSECSTZ              varchar(64)          null,
   JBZDMC               varchar(100)         null,
   JBZDDM               varchar(20)          null,
   BLZDMC               varchar(100)         null,
   BLZDBM               varchar(20)          null,
   JBZTDM               varchar(20)          null,
   SSZDYY               varchar(256)         null,
   SSZDBM               varchar(20)          null,
   RYQT                 varchar(16)          null,
   RYQXS                varchar(16)          null,
   RYQF                 varchar(16)          null,
   RYHT                 varchar(16)          null,
   RYHXS                varchar(16)          null,
   RYHF                 varchar(16)          null,
   ZKKBMC               varchar(32)          null,
   ZKKBDM               varchar(64)          null,
   CYZYQZRQ             datetime             null,
   CYZYZDMC             varchar(100)         null,
   CYZYJBZDDM           varchar(20)          null,
   RYZYJBZDDM           varchar(20)          null,
   CYQTQZRQ             datetime             null,
   CYQTZDMC             varchar(100)         null,
   CYQTJBZDDM           varchar(20)          null,
   RYQTJBZDDM           varchar(20)          null,
   LYFS                 varchar(4)           null,
   LYYYMC               varchar(70)          null,
   GMYW                 varchar(200)         null,
   ABOXXDM              char(1)              null,
   RHXXDM               varchar(1)           null,
   SSDM                 varchar(20)          null,
   SSRQ                 datetime             null,
   SSYSGH               varchar(64)          null,
   SSYSXM               varchar(30)          null,
   SSYSZ1GH             varchar(64)          null,
   SSYSZ1XM             varchar(30)          null,
   SSYSZ2GH             varchar(64)          null,
   SSYSZ2XM             varchar(30)          null,
   SSCZMC               varchar(128)         null,
   SSJB                 varchar(4)           null,
   SSQKLBDM             varchar(2)           null,
   QKYHDJ               varchar(4)           null,
   MZYSGH               varchar(64)          null,
   MZYSXM               varchar(30)          null,
   ZYCS                 int                  null,
   SJZYTS               decimal(5)           null,
   CYBFDM               varchar(20)          null,
   CYKBBFMC             varchar(100)         null,
   CYKBDM               varchar(64)          null,
   CYKBMC               varchar(32)          null,
   ZKRQ                 datetime             null,
   ZKYSBM               varchar(64)          null,
   ZKYSXM               varchar(30)          null,
   ZKHSBM               varchar(64)          null,
   ZKHSXM               varchar(30)          null,
   CYZZYJHMD            varchar(250)         null,
   YLFKFSDM             varchar(2)           null,
   ZFY                  decimal(15,3)        null,
   ZFJE                 decimal(15,3)        null,
   YLFWF                decimal(15,3)        null,
   ZLCZF                decimal(15,3)        null,
   HLF                  decimal(15,3)        null,
   ZHYLQTFY             decimal(15,3)        null,
   BLZDF                decimal(15,3)        null,
   SYSZDF               decimal(15,3)        null,
   YXXZDF               decimal(15,3)        null,
   LCZDXMF              decimal(15,3)        null,
   FSSZLXMF             decimal(15,3)        null,
   WLZLF                decimal(15,3)        null,
   SSZLF                decimal(15,3)        null,
   SSMZF                decimal(15,3)        null,
   SSF                  decimal(15,3)        null,
   KFF                  decimal(15,3)        null,
   ZYZLF                decimal(15,3)        null,
   XYF                  decimal(15,3)        null,
   KJYWF                decimal(15,3)        null,
   ZCHYF                decimal(15,3)        null,
   ZCYF                 decimal(15,3)        null,
   XF                   decimal(15,3)        null,
   BDBLZPF              decimal(15,3)        null,
   QDBLZPF              decimal(15,3)        null,
   NXYZLZPF             decimal(15,3)        null,
   XBYZLZPF             decimal(15,3)        null,
   JCYYCLF              decimal(15,3)        null,
   ZLYYCLF              decimal(15,3)        null,
   SSYYCLF              decimal(15,3)        null,
   QTF                  decimal(15,3)        null,
   MJ                   varchar(16)          not null,
   TBRQ                 datetime             not null,
   SCZT                 varchar(1)           not null,
   CS_JYBZ              int                  not null,
   SCSJ                 datetime             not null,
   constraint PK_GXBZ_EMR_ZYBASY primary key (ZYLSH, XGBZ)
)
go
